package com.deyuanyun.pic.ctrl.excelImport;

import com.deyuanyun.pic.common.validator.annotations.DataValidate;
import com.deyuanyun.pic.ctrl.annotation.*;
import com.deyuanyun.pic.ctrl.util.AutoImportInterface;
import com.deyuanyun.pic.ctrl.validatefun.AutoDevice;
import com.deyuanyun.pic.ctrl.validatefun.AutoPile;
import com.deyuanyun.pic.ctrl.validatefun.EnumValidata;
import com.deyuanyun.pic.ctrl.validatefun.PipeLineValidata;

import java.util.Date;

/**

说明:Z:\excel\阴保有效性\A7跨接线检测记录表（导入、导出）.xls

**/
@DbTable(name="PIC_CTRL_EXINSP_CPJUMPER",startRow=5,sumCell=19,excelName="跨接线检测记录表.xls")
public class PicCtrlExinspCpjumperExcel implements AutoImportInterface
{

      /**
      * 管道名称
      */
      @Head( name="管道名称",row=2,cell=0)
      @DbFiled( name="PIPE_LINE_ID" ,type="VARCHAR2")
      @DataValidate(notNull = true,myFunction = PipeLineValidata.class,myFunctionMessage="管道信息与项目要求管道不一致")
      private String pipeLineId;




      /**
      * 设备编号
      */
      @DeviceAnnotation(name="cpjumperId")
      @Head( name="设备编号",row=2,cell=1)
      @DbFiled( name="CUSTOM_NUMBER" ,type="CHAR")
      @DataValidate(notNull = true,myFunction = AutoDevice.class,myFunctionMessage = "设备不存在")
      private String customNumber;

      /**
      * 测试桩编号
      */
      @Head( name="测试桩编号",row=2,cell=2)
      @DbFiled( name="TEST_STATION_ID" ,type="CHAR")
      @DataValidate(myFunction = AutoPile.class,myFunctionMessage="测试桩不存在")
      private String testStationId;

      /**
      * 跨接线连通时电位
      */
      @Head( name="跨接线连通时电位",row=3,cell=3)
      @DbFiled( name="CROSSWIRE_CONNECTTION" ,type="NUMBER")
      @DataValidate(notNull = true)
      private String crosswireConnecttion;

      /**
      * 跨接线断开后电位
      */
      @Head( name="跨接线断开后电位",row=4,cell=4)
      @DbFiled( name="CROSSWIRE_DIS_CONNECTION1" ,type="NUMBER")
      @DataValidate(notNull = true)
      private String crosswireDisConnection1;

      /**
      * 连接管道名称
      */
      @Head( name="连接管道名称",row=4,cell=5)
      @DbFiled( name="CONNECTING_PIPE_NAME1" ,type="VARCHAR2")
      @DataValidate(notNull = true,lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      private String connectingPipeName1;

      /**
      * 跨接线断开后电位
      */
      @Head( name="跨接线断开后电位",row=4,cell=6)
      @DbFiled( name="CROSSWIRE_DIS_CONNECTION2" ,type="NUMBER")
      @DataValidate(notNull = true)
      private String crosswireDisConnection2;

      /**
      * 连接管道名称
      */
      @Head( name="连接管道名称",row=4,cell=7)
      @DbFiled( name="CONNECTING_PIPE_NAME2" ,type="VARCHAR2")
      @DataValidate(notNull = true,lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      private String connectingPipeName2;

      /**
      * 跨接线断开后电位
      */
      @Head( name="跨接线断开后电位",row=4,cell=8)
      @DbFiled( name="CROSSWIRE_DIS_CONNECTION3" ,type="NUMBER")
      @DataValidate()
      private String crosswireDisConnection3;

      /**
      * 连接管道名称
      */
      @Head( name="连接管道名称",row=4,cell=9)
      @DbFiled( name="CONNECTING_PIPE_NAME3" ,type="VARCHAR2")
      @DataValidate(lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      private String connectingPipeName3;

      /**
      * 跨接线焊点检查
      */
      @Head( name="跨接线焊点检查",row=2,cell=10)
      @DbFiled( name="SOLDER_JOINT_INSPECTION" ,type="VARCHAR2")
      @DataValidate(lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      private String solderJointInspection;

      /**
      * 异常记录
      */
      @Head( name="异常记录",row=2,cell=11)
      @DbFiled( name="FAULT_RECORD" ,type="VARCHAR2")
      @DataValidate(lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      private String faultRecord;

      /**
      * 是否有异常
      */
      @EnumVail(enumClass=com.deyuanyun.pic.ctrl.enumeration.AbnormalEnum.class,valMethod="getVal")
      @Head( name="是否有异常",row=2,cell=12)
      @DbFiled( name="ABNORMAL" ,type="VARCHAR2")
      @DataValidate(myFunctionMessage="可选值无对应值",myFunction = EnumValidata.class)
      private String abnormal;

      /**
      * 处理措施
      */
      @Head( name="处理措施",row=2,cell=13)
//      @DbFiled( name="TREATMENTMEASURES" ,type="null")
      @MappingTable(clas=PicCtrlExinspFault.class,autoFiled="treatmentMeasures",fkey="exinspRecodeId")
      @DataValidate()
      private String treatmentmeasures;


      /**
      * 检测日期
      */
      @Head( name="检测日期",row=2,cell=14)
      @DbFiled( name="DETECTIONG_DETE" ,type="DATE")
      @DataValidate(type = Date.class,notNull = true)
      private String detectiongDete;

      /**
      * 记录人
      */
      @Head( name="记录人",row=2,cell=15)
      @DbFiled( name="RECORDER" ,type="VARCHAR2")
      @DataValidate(lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      @AutoLoginUser
      private String recorder;

      /**
      * 记录时间
      */
      @Head( name="记录时间",row=2,cell=16)
      @DbFiled( name="RECORD_TIME" ,type="DATE")
      @DataValidate(type = Date.class)
      @AutoDate
      private String recordTime;

      /**
      * 备注
      */
      @Head( name="备注",row=2,cell=17)
      @DbFiled( name="REMARKS" ,type="VARCHAR2")
      @DataValidate(lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      private String remarks;

      /**
      * id
      */
      @DbFiled( name="ID_")
      @AutoId
      private String id;


    @DbFiled( name="CPJUMPER_ID" ,type="CHAR")
    private String cpjumperId;

    @AutoExinspTask
    @DbFiled( name="EXINSP_TASK_ID",type="VARCHAR2")
    private String exinspTaskId;

    @DbFiled( name="DATA_STATED",type="VARCHAR2")
    private String dataStated;

    @DbFiled( name="IS_NEWEST",type="NUMBER")
    private String isNewset;

    public String getIsNewset() {
        return isNewset;
    }

    public void setIsNewset(String isNewset) {
        this.isNewset = isNewset;
    }

    public String getDataStated() {
        return dataStated;
    }

    public void setDataStated(String dataStated) {
        this.dataStated = dataStated;
    }

    public String getExinspTaskId() {
        return exinspTaskId;
    }

    public void setExinspTaskId(String exinspTaskId) {
        this.exinspTaskId = exinspTaskId;
    }




    public String getCpjumperId()
    {

        return  this.cpjumperId;
    }
    public void setCpjumperId(String cpjumperId)
    {

      this.cpjumperId=cpjumperId;
    }


    public String getTestStationId()
    {

        return  this.testStationId;
    }
    public void setTestStationId(String testStationId)
    {

      this.testStationId=testStationId;
    }


    public String getCrosswireConnecttion()
    {

        return  this.crosswireConnecttion;
    }
    public void setCrosswireConnecttion(String crosswireConnecttion)
    {

      this.crosswireConnecttion=crosswireConnecttion;
    }

    public String getPipeLineId() {
        return pipeLineId;
    }

    public void setPipeLineId(String pipeLineId) {
        this.pipeLineId = pipeLineId;
    }

    public String getCrosswireDisConnection1() {
        return crosswireDisConnection1;
    }

    public void setCrosswireDisConnection1(String crosswireDisConnection1) {
        this.crosswireDisConnection1 = crosswireDisConnection1;
    }

    public String getConnectingPipeName1() {
        return connectingPipeName1;
    }

    public void setConnectingPipeName1(String connectingPipeName1) {
        this.connectingPipeName1 = connectingPipeName1;
    }

    public String getCrosswireDisConnection2() {
        return crosswireDisConnection2;
    }

    public void setCrosswireDisConnection2(String crosswireDisConnection2) {
        this.crosswireDisConnection2 = crosswireDisConnection2;
    }

    public String getConnectingPipeName2() {
        return connectingPipeName2;
    }

    public void setConnectingPipeName2(String connectingPipeName2) {
        this.connectingPipeName2 = connectingPipeName2;
    }

    public String getCrosswireDisConnection3() {
        return crosswireDisConnection3;
    }

    public void setCrosswireDisConnection3(String crosswireDisConnection3) {
        this.crosswireDisConnection3 = crosswireDisConnection3;
    }

    public String getConnectingPipeName3() {
        return connectingPipeName3;
    }

    public void setConnectingPipeName3(String connectingPipeName3) {
        this.connectingPipeName3 = connectingPipeName3;
    }

    public String getSolderJointInspection()
    {

        return  this.solderJointInspection;
    }
    public void setSolderJointInspection(String solderJointInspection)
    {

      this.solderJointInspection=solderJointInspection;
    }


    public String getFaultRecord()
    {

        return  this.faultRecord;
    }
    public void setFaultRecord(String faultRecord)
    {

      this.faultRecord=faultRecord;
    }


    public String getAbnormal()
    {

        return  this.abnormal;
    }
    public void setAbnormal(String abnormal)
    {

      this.abnormal=abnormal;
    }


    public String getTreatmentmeasures()
    {

        return  this.treatmentmeasures;
    }
    public void setTreatmentmeasures(String treatmentmeasures)
    {

      this.treatmentmeasures=treatmentmeasures;
    }


    public String getDetectiongDete()
    {

        return  this.detectiongDete;
    }
    public void setDetectiongDete(String detectiongDete)
    {

      this.detectiongDete=detectiongDete;
    }


    public String getRecorder()
    {

        return  this.recorder;
    }
    public void setRecorder(String recorder)
    {

      this.recorder=recorder;
    }


    public String getRecordTime()
    {

        return  this.recordTime;
    }
    public void setRecordTime(String recordTime)
    {

      this.recordTime=recordTime;
    }


    public String getRemarks()
    {

        return  this.remarks;
    }
    public void setRemarks(String remarks)
    {

      this.remarks=remarks;
    }


    public String getId()
    {

        return  this.id;
    }
    public void setId(String id)
    {

      this.id=id;
    }


    public String getCustomNumber() {
        return customNumber;
    }

    public void setCustomNumber(String customNumber) {
        this.customNumber = customNumber;
    }
}